Device Event Mapping scripts for SQL

In the …\MSSQLDatabaseFiles\DeviceEventMappingScripts\ directory you will find the following device mapping script. Prior to executing the script, check with Itron product management, services, or support to verify that you have the latest version of the scripts.

  • create_event_mapping_sqlserver_openway.sql. For Itron OpenWay.

    To enable IEE to import events into the system, you must map event codes and labels to IEE internal device event codes. This capability depends on the external system and requires you to use SQL scripts to populate the database table that facilitates the mapping process.

    To execute the script, modify it to reference the actual external system name to which you are mapping, as it is defined in IEE.

Editing the Device Event Mapping scripts (SQL Server)

  1. Find the following line:

    SELECT @v_externalSystem    = 'ReplaceWithExternalSystemName'

  2. Replace the text ‘ReplaceWithExternalSystemName’ with the actual External System Name as defined in IEE.

  3. Run the SQL query.

    You can verify the settings were imported successfully by going to the IEE client.

Verifying the Device Events imported successfully in the IEE rich client

  1. Go to Device Events > Event Code Mappings.

  2. Use the External System dropdown menu to select the external system ID. If the external system name displays, the settings imported successfully.

Related topics: